Re: AW: Classpath for MSSQLServer JDBC Driver
Re: AW: Classpath for MSSQLServer JDBC Driver
- Subject: Re: AW: Classpath for MSSQLServer JDBC Driver
- From: "Jonathan Fleming" <email@hidden>
- Date: Mon, 26 May 2003 15:33:30 +0100
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;DatabaseName=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
_______________________________________________
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.