Re: Classpath for MSSQLServer JDBC Driver
Re: Classpath for MSSQLServer JDBC Driver
- Subject: Re: Classpath for MSSQLServer JDBC Driver
- From: "Jonathan Fleming" <email@hidden>
- Date: Tue, 27 May 2003 11:35:15 +0100
OK J|rgen,
I'll wait for a few more responses before I start changing things. Now that
everyone is back to work after the holidays the list should get busy again.
It's been painfully quiet these last few days as both UK and USA have had
national holidays.
Thanks all the same
Jonathan ;^)
From: J|rgen Mendes <email@hidden>
To: "Jonathan Fleming" <email@hidden>
CC: <email@hidden>
Subject: Re: Classpath for MSSQLServer JDBC Driver
Date: Tue, 27 May 2003 11:38:35 +0200
Don't know which solution fits best for you. I don't have experience on
connecting EOModeler to MS SQLServer. I tried only to give you a hint by
explainig on how we solved our problems. Sorry.
Regards
J|rgen
-----Urspr|ngliche Nachricht-----
Von: Jonathan Fleming [mailto:email@hidden]
Gesendet: Montag, 26. Mai 2003 16:34
An: email@hidden
Cc: email@hidden; email@hidden
Betreff: Re: AW: Classpath for MSSQLServer JDBC Driver
>From: J|rgen Mendes <email@hidden>
>To: "Jonathan Fleming" <email@hidden>
>CC: <email@hidden>
>Subject: AW: Classpath for MSSQLServer JDBC Driver
>Date: Mon, 26 May 2003 13:22:25 +0200
>
>Hi Jonathan,
>not sure if it helps you. We just had identical problems connecting
>EOModeler to PostgreSQL. EOModeler is a bit old, so we put a jdk 1.1
>compatible driver to Apple\Library\Java and added the path to this .jar
>file
>to DefaultClasspath in JavaConfig.plist.
I will give this a try but first I'll update you. I have managed to get a
connection and now I have another problem which is still to do with
EOModeller not working properly:
having used the connection below as set out in EOModeller dialog box,
USER=sa
PASSWORD=xxxxxxxx
URL=jdbc:microsoft:sqlserver://192.168.0.4\\DEVBOXSQLSERVER:1433;DatabaseNam
e=JandM;SelectMethod=cursor
DRIVER=Empty
PLUGIN=Empty
I no longer get an error message such as these:
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for
user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
but when I go to to the Menu, Property > Generate SQL I get
com.Microsoft..jdbc.sqlserver.SQLServerDriver come up in a dialog box with
an OK button, I click OK and all seems well still. No errors reported.
I then click the Tables button in the Generate SQL Dialog box and I can see
these tables: dbo.dtproperties, dbo.sysconstraints, dbo.syssegments,
however, when i click Execute SQL to create a table with primary and
foriegn
key constraints, I get the error message below:
An unexpected error has occurred which may cause EOModeler to malfunction.
You may want to save copies of your open documents and quit EOModeler.
Error: java/lang/IllegalArgumentException:
com.Microsoft..jdbc.sqlserver.SQLServerDriver
Stack Trace:
java.lang.IllegalArgumentException:
com.Microsoft..jdbc.sqlserver.SQLServerDriver
at JDBCContext.connect(Compiled Code)
at JDBCContext._tryConnect(JDBCContext.java:246)
at JDBCContext._fetchJDBCInfo(Compiled Code)
at JDBCPlugIn.jdbcInfo(JDBCPlugIn.java:848)
at MicrosoftPlugIn.jdbcInfo(MicrosoftPlugIn.java:66)
at JDBCAdaptor.jdbcInfo(JDBCAdaptor.java:228)
at JDBCExpressionFactory.createExpression(JDBCExpressionFactory.java:22)
at
EOSQLExpressionFactory.expressionForEntity(EOSQLExpressionFactory.java:67)
at
EOSynchronizationFactory._expressionForEntity(EOSynchronizationFactory.java:
984)
at EOSynchronizationFactory.createTableStatementsForEntityGroup(Compiled
Code)
at EOSynchronizationFactory.createTableStatementsForEntityGroups(Compiled
Code)
at EOSynchronizationFactory.schemaCreationStatementsForEntities(Compiled
Code)
at EOSynchronizationFactory.schemaCreationScriptForEntities(Compiled Code)
Should I still use your solution or some other solution now?
Regards
Jonathan :^|
>
>Hoping to help you
>Juergen
>
>-----Urspr|ngliche Nachricht-----
>Von: email@hidden
>[mailto:email@hidden]Im Auftrag von Jonathan
>Fleming
>Gesendet: Donnerstag, 22. Mai 2003 21:41
>An: email@hidden; email@hidden
>Betreff: Classpath for MSSQLServer JDBC Driver
>
>
>I've installed MS SQL Server 2000 and have the JDBC .jar files that need
to
>be used in classpath, since I am using WO5.2 can I simply copy these into
>the C:\Apple\Local\Library\WebObjects\Extensions directory?
>
>The documentation says: Set your system CLASSPATH to include the
following
>entries,
>where install_dir is the path to your SQL Server 2000 Driver for
>JDBC installation directory:
>install_dir/lib/msbase.jar
>install_dir/lib/msutil.jar
>install_dir/lib/mssqlserver.jar
>I'm using Windows 2000, this is the Windows Example
>CLASSPATH=.;c:\Microsoft SQL Server 2000 Driver for
>JDBC\lib\msbase.jar;c:\Microsoft SQL Server 2000 Driver for
>JDBC\lib\msutil.jar;c:\Microsoft SQL Server 2000 Driver for JDBC
>\lib\mssqlserver.jar
>
>Just conforming. Once this is done I should be able to connect using my
>EOModel with something like this:
>jdbc:microsoft:sqlserver://server_name:1433
>For example, to specify a connection URL that includes the user
>ID "username" and the password "secret":
>Connection conn = DriverManager.getConnection
>("jdbc:microsoft:sqlserver://server1:1433","username","secret");
>
>Thanks for any help
>Jonathan
>
>_________________________________________________________________
>Express yourself with cool emoticons - download MSN Messenger today!
>http://www.msn.co.uk/messenger
>
>_______________________________________________
>WebObjects-dev mailing list
>email@hidden
>http://www.omnigroup.com/mailman/listinfo/webobjects-dev
>
>
_________________________________________________________________
Hotmail messages direct to your mobile phone http://www.msn.co.uk/msnmobile
_________________________________________________________________
Use MSN Messenger to send music and pics to your friends
http://www.msn.co.uk/messenger
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.