JDBC Driver With CF 8

[Aaron Renfroe]

Hello All!

 

I am trying to set up a datasource using JDBC instead of ODBC with CF8.

 

I have downloaded and installed the sqljdbc.jar and placed it in
C:\ColdFusion8\lib  (This is a localhost/test server)

 

Inside of the CF Administrator/Datasources

 

Its asking me for information that I'm not sure how to answer:

 

CF Data Source Name: Griffin

JDBC URL: C:\ColdFusion8\lib  ??? is that right?

Driver Class: Not sure what it wants or where to get it

Username: SQL username?

Password: SQL Password?

 

 

I have lost a day and half my hair to trying to set up a ODBC with SQL
Express 08 and CF Server. Please Help J



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3161
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6

[Raymond Thompson]

I run SQL Express 9.0 with CF version 8 without difficulties. Perhaps I can
help. Email me privately and I can show you some of my setting. I am using
ODBC and not JDBC.

Ray Thompson
Tau Beta Pi (www.tbp.org)
The Engineering Honor Society
865-546-4578

-----Original Message-----
From: Aaron Renfroe [mailto:aaron@...]
Sent: Tuesday, December 16, 2008 1:53 PM
To: sql
Subject: JDBC Driver With CF 8

Hello All!

 

I am trying to set up a datasource using JDBC instead of ODBC with CF8.

 

I have downloaded and installed the sqljdbc.jar and placed it in
C:\ColdFusion8\lib  (This is a localhost/test server)

 

Inside of the CF Administrator/Datasources

 

Its asking me for information that I'm not sure how to answer:

 

CF Data Source Name: Griffin

JDBC URL: C:\ColdFusion8\lib  ??? is that right?

Driver Class: Not sure what it wants or where to get it

Username: SQL username?

Password: SQL Password?

 

 

I have lost a day and half my hair to trying to set up a ODBC with SQL
Express 08 and CF Server. Please Help J





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3162
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6

[Peter Boughton]

> JDBC URL: C:\ColdFusion8\lib  ??? is that right?

No, that's a Windows file path, pointing at the ColdFusion lib
directory, not a JDBC database connection URL (which points at the
database server)

What you want will be in the format:
jdbc:<something>:<server>:<port>/<dbname>

Where everything <likethis> is to be replaced with the correct value.
(and possibly with some additional arguments after the dbname.)


> Driver Class: Not sure what it wants or where to get it

That should have been provided (along with the JDBC URL) from wherever
you grabbed the sqljbc.jar


> Username: SQL username?
>
> Password: SQL Password?

If you don't have a username/password, leave these blank.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3163
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6

[cfSearching]

>I am trying to set up a datasource using JDBC instead of ODBC with CF8.

Why not just use the built in jdbc drivers?  On the datasource page, select "MS SQL Server" from the driver list and enter the settings for your database.  Here is an example. Your settings may differ:

Server:     127.0.0.1
Port:       1433  (** default)
Database:   MyTestDatabaseName
User:       mySQLServerUserName
Password:   mySQLServerPassword

>I have downloaded and installed the sqljdbc.jar and placed it in
>C:\ColdFusion8\lib  (This is a localhost/test server)


I am using the MS SQL 2005 driver on a test machine. Here are my settings. (Be aware the driver class _is_ case sensitive)

JDBC URL: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=MyDatabaseName
Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
User name:  mySQLServerUserName
Password:  mySQLServerPassword



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3164
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6

[Jacob-20]

From my CF8 server on 2008 with MS SQL 2005 backend:

CF Data source Name: test
JDBC URL: jdbc:macromedia:sqlserver://10.1.1.101:1433;
                                databaseName=myDatabase;SelectMethod=direct;
                                sendStringParametersAsUnicode=false;
                                MaxPooledStatements=1000
Driver Class: macromedia.jdbc.MacromediaDriver
Driver Name: SQL 2005
Username: ****
Password: ****

In the JDBC URL.. change the ip address (port if necessary) and database
name.


-----Original Message-----
From: Aaron Renfroe [mailto:aaron@...]
Sent: Tuesday, December 16, 2008 10:53 AM
To: sql
Subject: JDBC Driver With CF 8

Hello All!

 

I am trying to set up a datasource using JDBC instead of ODBC with CF8.

 

I have downloaded and installed the sqljdbc.jar and placed it in
C:\ColdFusion8\lib  (This is a localhost/test server)

 

Inside of the CF Administrator/Datasources

 

Its asking me for information that I'm not sure how to answer:

 

CF Data Source Name: Griffin

JDBC URL: C:\ColdFusion8\lib  ??? is that right?

Driver Class: Not sure what it wants or where to get it

Username: SQL username?

Password: SQL Password?

 

 

I have lost a day and half my hair to trying to set up a ODBC with SQL
Express 08 and CF Server. Please Help J





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3165
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6

[Mike Kear-2]

I'm heartily sick of the tedious way I have to spend half a day or more EACH
WEEK uploading and downloading databases from my SQLServer2005 web sites.
I'm going to have another go at learning the best way to do this . .

Can someone please give me some help...    IN the old days I used to have a
DTS task running overnight automatically, copying databases to and from my
dev environment to the production web sites.  

Since SQLServer2005 there has been no way that I can find,  to create a DTS
task and reuse it  EACH TIME I have to create it, and regardless of whether
I save the DTS task or not,  it's not available next time for me to reuse.
I have ot create it all over again.    Needless to say it's really PISSING
ME OFF!

Can someone please tell me how I can create a method of copying entire
databases which might have 40tables or more with the indexes, and key
relationships etc from remote servers to my local database server,  or
conversely from my dev environment to my production server.    

And also how I can do this in a way that the task is repeatable without
having to be created every time.

I've tried using Visual Studio 2005 but that has finally defeated me.  I can
never find what I want to use,  and the MS Help files are total gobbldegook
to me.   I cant make head nor tail of it.  After 3 years of wrestling with
Visual Studio I have had to give up.  There's no way to save any file from
that and reuse it.   Not that I've found anyway.    The best I've ever
managed to do is create a solution,  and run debug every time.   And that
takes 30 minutes to an hour to run a simple job of copying 3 tables, and
ties up my machine completely for the duration.

I'm sure my problem is that I'm trying to use the wrong tools,  or that I
just don't know how to use the tools correctly,  but I'm despairing of ever
getting back to the neat and tidy way I had to do this in the old
SQLServer2000 days.



Cheers
Mike Kear
Windsor, NSW, Australia
0422 985 585
Adobe Certified Advanced ColdFusion Developer
AFP Webworks Pty Ltd
http://afpwebworks.com
Full Scale ColdFusion hosting from A$15/month





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3166
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6

[Mike Kear-2]

Incidentally, just as an additional comment to my plea ...

I cant use the copy database wizard, because it's a shared server and I
don't have admin rights.    So I cant create a database on the remote server
using SQLServer management studio.

For the same reason I cant create a backup and then restore it on the other
server..

For the same reason I cant use replication in any way.

For the same reason, detaching, FTP then attach to the other server is out
as well.


I think Microsoft forgot entirely about the thousands of people using shared
hosting servers when they developed SQLServer2005.   And I'm told there's no
provision for it in the new 2008 version either.   <sigh>

Cheers
Mike Kear
Windsor, NSW, Australia
0422 985 585
Adobe Certified Advanced ColdFusion Developer
AFP Webworks Pty Ltd
http://afpwebworks.com
Full Scale ColdFusion hosting from A$15/month




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3167
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6

[Manish Grewal]

Hi Kear,



Looks like what you are looking for is a script to automate your manual process of uploading and downloading databases. What are the actual commands you use for uploading and downloading? Maybe perl/python or another such scripting language that you are familiar with will be the right tool. These languages are much easier to pick up than a traditional programming language like C, Java etc and there's a large collection of examples, libraries, online help etc. See CPAN.org for Perl as an example.



Hope that helps!


Manish Grewal
Senior Consultant
[cid:image001.png@...] www.headstrong.com<http://www.headstrong.com/>


> -----Original Message-----

> From: Michael Kear [mailto:mkear@...]

> Sent: Monday, January 05, 2009 5:53 AM

> To: sql

> Subject: RE: How do i . Copy a database to a remote server?

>

> Incidentally, just as an additional comment to my plea ...

>

> I cant use the copy database wizard, because it's a shared server and I

> don't have admin rights.    So I cant create a database on the remote

> server

> using SQLServer management studio.

>

> For the same reason I cant create a backup and then restore it on the

> other

> server..

>

> For the same reason I cant use replication in any way.

>

> For the same reason, detaching, FTP then attach to the other server is

> out

> as well.

>


 
***The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review,retransmission,dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.***


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3168
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6

[Konopka, David]

Hi Michael,

I'm not sure if someone else has already gotten back to you --

Check out the SQL Server Hosting Toolkit. There's two tools, the one you want is the Database Publishing Wizard. It will script out all the objects, permissions, and data from your source database. Then you can take the script and run it against your destination database.

This is something that's been built into MySQL clients for quite a while now. It's always annoyed me that SQL Manager tools haven't had anything similar. But the Database Publishing Wizard has served me well for hosted databases.

Here's the URL: http://www.codeplex.com/sqlhost

Dave Konopka
http://imakewebjunk.com

-----Original Message-----
From: Michael Kear [mailto:mkear@...]
Sent: Sunday, January 04, 2009 7:23 PM
To: sql
Subject: RE: How do i . Copy a database to a remote server?

Incidentally, just as an additional comment to my plea ...

I cant use the copy database wizard, because it's a shared server and I
don't have admin rights.    So I cant create a database on the remote server
using SQLServer management studio.

For the same reason I cant create a backup and then restore it on the other
server..

For the same reason I cant use replication in any way.

For the same reason, detaching, FTP then attach to the other server is out
as well.


I think Microsoft forgot entirely about the thousands of people using shared
hosting servers when they developed SQLServer2005.   And I'm told there's no
provision for it in the new 2008 version either.   <sigh>

Cheers
Mike Kear
Windsor, NSW, Australia
0422 985 585
Adobe Certified Advanced ColdFusion Developer
AFP Webworks Pty Ltd
http://afpwebworks.com
Full Scale ColdFusion hosting from A$15/month






~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3169
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6

[Mike Kear-2]

@@Dave:  Thanks for your reply Dave.   Actually SQLServer USED to have
everything I needed right up to SQLServer2000.   Then when they made the
2005 version they wrecked everything for shared hosting.  I'm not sure how
come I'm the only person apparently with this problem, because there must be
millions of SQLServer2005 databases in shared hosting environments.

I have made such a fuss at Microsoft over it, I have eventually made contact
with one of the developers on that team, and he told me that they had never
thought shared hosting might be a factor they should consider.   To my
astonishment,  they thought every web site with MSSQLServer would be on a
server owned by the web site owner.  Good grief!!

To my dismay, this guy also told me that the feature list for SQLServer2008
had already been frozen and shared hosting customers were left out in the
cold again.   It would be at least 2010 before any features to cater for
shared hosting could be incorporated in the product.

Anyway.. .    by a circuitous route, I found out about the Database
Publishing Wizard, and I'm surprised that in all my fussing and yelling at
MS about this problem, no one there thought to tell me about it.   Anyway I
downloaded it, and it gives me a 85MB long SQLstatement (or series of
statements) that takes an hour to execute.   Means in order ot update the
database, I cant upload the changes,  I have to upload the whole database,
and take the site off line for an hour.    I'm pretty grumpy about that but
it's a step forward, if only a small one.

I guess what I need to do is migrate away from MS SQLServer but that isn't
something I'm eager to do in a hurry.  There are all kinds of implications
to changing databases.  Not the least of which is a whole host of tests to
ensure the integrity of the data I'm moving and rewriting all my code
generators that write my components.

GRRRRRRRRRRRRRRRRRRRRRRR!!!!!!!!!!!!!!!!!

Thanks for your input Dave.

@@Manish:   I got into Coldfusion 12 years ago because I was so frustrated
with Perl - I appreciate your suggestion, and I'm sure you're right but I
will cut off an arm with a rusty piece of tin can before I'll look at Perl
again.  <g>

Cheers
Mike Kear
Windsor, NSW, Australia
0422 985 585
Adobe Certified Advanced ColdFusion Developer
AFP Webworks Pty Ltd
http://afpwebworks.com
Full Scale ColdFusion hosting from A$15/month




-----Original Message-----
From: Konopka, Dave [mailto:dkonopka@...]
Sent: Tuesday, 6 January 2009 6:11 AM
To: sql
Subject: SPAM-MED: RE: How do i . Copy a database to a remote server?

Hi Michael,

I'm not sure if someone else has already gotten back to you --

Check out the SQL Server Hosting Toolkit. There's two tools, the one you
want is the Database Publishing Wizard. It will script out all the objects,
permissions, and data from your source database. Then you can take the
script and run it against your destination database.

This is something that's been built into MySQL clients for quite a while
now. It's always annoyed me that SQL Manager tools haven't had anything
similar. But the Database Publishing Wizard has served me well for hosted
databases.

Here's the URL: http://www.codeplex.com/sqlhost

Dave Konopka
http://imakewebjunk.com

-----Original Message-----
From: Michael Kear [mailto:mkear@...]
Sent: Sunday, January 04, 2009 7:23 PM
To: sql
Subject: RE: How do i . Copy a database to a remote server?

Incidentally, just as an additional comment to my plea ...

I cant use the copy database wizard, because it's a shared server and I
don't have admin rights.    So I cant create a database on the remote server
using SQLServer management studio.

For the same reason I cant create a backup and then restore it on the other
server..

For the same reason I cant use replication in any way.

For the same reason, detaching, FTP then attach to the other server is out
as well.


I think Microsoft forgot entirely about the thousands of people using shared
hosting servers when they developed SQLServer2005.   And I'm told there's no
provision for it in the new 2008 version either.   <sigh>

Cheers
Mike Kear
Windsor, NSW, Australia
0422 985 585
Adobe Certified Advanced ColdFusion Developer
AFP Webworks Pty Ltd
http://afpwebworks.com
Full Scale ColdFusion hosting from A$15/month








~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3170
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6

[Maureen-2]

An 85 MG SQL statement?  How big is that database?   Table copies in
TOAD would take less time than that.

On Tue, Jan 6, 2009 at 9:35 PM, Michael Kear <mkear@...> wrote:

> Anyway.. .    by a circuitous route, I found out about the Database
> Publishing Wizard, and I'm surprised that in all my fussing and yelling at
> MS about this problem, no one there thought to tell me about it.   Anyway I
> downloaded it, and it gives me a 85MB long SQLstatement (or series of
> statements) that takes an hour to execute.   Means in order ot update the
> database, I cant upload the changes,  I have to upload the whole database,
> and take the site off line for an hour.    I'm pretty grumpy about that but
> it's a step forward, if only a small one.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3171
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6