This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallAnywhere
- :
- InstallAnywhere Forum
- :
- Re: jdbc error
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 15, 2008
02:47 PM
jdbc error
I'm having some problems with my installer executing a simple .sql script. My host system is Windows 2003 with SQL Server 2005 installed (same box). I am passing in the correct credentials.
When the installer tries to execute my script, I get a cryptic message in the log: An error occurred while running the script: (102) Incorrect syntax near 'GO'
I looked around line 102 of the file.sql - didn't see any problems.
I can use Microsoft's osql.exe to install the same script as well as run it with SQL Server 2005's manager tools. I won't necessarliy have osql.exe on the install boxes - so need the JDBC implementation working.
When the installer tries to execute my script, I get a cryptic message in the log: An error occurred while running the script: (102) Incorrect syntax near 'GO'
I looked around line 102 of the file.sql - didn't see any problems.
I can use Microsoft's osql.exe to install the same script as well as run it with SQL Server 2005's manager tools. I won't necessarliy have osql.exe on the install boxes - so need the JDBC implementation working.
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 16, 2008
04:27 PM
In my experience, I have found out that those "simple" sql scripts for MSSQL are not JDBC compliant. They are more like batch commands. That is why it works fine in the manager tools and osql.exe.
I'm not sure what your final plan should be, but you may have to require the MSSQLServer client installed, or you have to re-write your sql scripts to be JDBC compilant.
If I'm off my rocker, please let me know.
I'm not sure what your final plan should be, but you may have to require the MSSQLServer client installed, or you have to re-write your sql scripts to be JDBC compilant.
If I'm off my rocker, please let me know.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 31, 2008
07:34 AM
I figured out my problem. It was the sql script. A sample of what we had:
some valid db commands
GO
The GO was the problem. I replaced that with a semicolon ; - fixed it. Using Microsoft's tools, osql.exe and query analyzer were ok with the GO. The JDBC was not.
ANyway, it works fine now and I don't require a database client on the boxes.
some valid db commands
GO
The GO was the problem. I replaced that with a semicolon ; - fixed it. Using Microsoft's tools, osql.exe and query analyzer were ok with the GO. The JDBC was not.
ANyway, it works fine now and I don't require a database client on the boxes.
![](/skins/images/CC38E504FC9E1309DC48ACFEB4925670/responsive_peak/images/icon_anonymous_message.png)